[dbo].[asi_HierarchyGetAdjacentSort]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_HierarchyGetAdjacentSort

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@adjacentHierarchyKey	uniqueidentifier	16
@addType	smallint	2

SQL Script

-- Calls asi_HierarchyGetAdjacentSortOut using an OUTPUT Variable but returning the answer in a result set
CREATE PROCEDURE [dbo].[asi_HierarchyGetAdjacentSort] @adjacentHierarchyKey uniqueidentifier, @addType smallint = 3 AS
DECLARE @NewSort int
BEGIN
EXEC asi_HierarchyGetAdjacentSortOut @adjacentHierarchyKey, @addType, @NewSort OUTPUT

SELECT @NewSort AS NewSort
END

GO

Uses

[dbo].[asi_HierarchyGetAdjacentSortOut]
dbo